f = open("data_init.sql","w",encoding='utf8')
f.write("USE market;\n")

w = open("data.txt","r",encoding="utf8").readlines()

for l in w:
    print(l[3:24].replace(" ",""),l[24:-1])
    f.write("INSERT INTO vacabulary(english,chinese) VALUE (\"{0}\",\"{1}\");\n".format(l[3:24].replace(" ",""),l[24:-1]))
